3.0 KB · ⇊ 3 parts · ⤓ Micron 3.0 KB · ⤓ HTML 28.2 KB

top

SQL:2016 or ISO/IEC 9075:2016 (under the general title "Information technology – Database languages – SQL") is the eighth revision of the ISO (1987) and ANSI (1986) standard for the SQL database query language. It was formally adopted in December 2016.cite-ref-1[1] The standard consists of 9 parts which are described in some detail in SQL. The next version is SQL:2023.

• New features

• See also

• References

• External links

SQL:2016 introduced 44 new optional features.cite-ref-2[2] 22 of them belong to the JSON functionality, ten more are related to polymorphic table functions. The additions to the standard include:

• JSON: Functions to create JSON documents, to access parts of JSON documents and to check whether a string contains valid JSON data

• Row Pattern Recognition: Matching a sequence of rows against a regular expression pattern

• Date and time formatting and parsing

• LISTAGG: A function to transform values from a group of rows into a delimited string

• Polymorphic table functions: table functions without predefined return type

• New data type DECFLOAT

Wikibooks has a book on the topic of:

Structured Query Language

• Structured Query Language

cite-note-11. ↑ "ISO/IEC 9075, 13249, and others". Retrieved 2017-03-15.

cite-note-22. ↑ "What's New in SQL:2016". Retrieved 2017-06-16.

• "SQL:2016", Catalogue (webshop), ISO.

• ISO/IEC TR 19075-5:2016: Row Pattern Recognition in SQL

• ISO/IEC TR 19075-6:2017: SQL support for JavaScript Object Notation (JSON)

• ISO/IEC TR 19075-7:2017: Polymorphic table functions in SQL